1. Data Management

Data Quality Studio


Data quality studio for Microsoft Dynamics 365 Finance and Supply Chain Management helps you control your data quality. You can apply data validation rules, duplicate check rules, and data action rules to keep your data clean and consistent.

This picture shows the data quality dimensions:

These data quality dimensions are covered by the Data quality studio in combination with D365 F&SCM:
  • Consistency: Is the data consistent between systems and entities? Do duplicate records exist? For example, you can check data consistency with duplicate check rules or a Data pattern type validation rule.
  • Validity: Are all data values within the value domains specified by the business? For example, you can check data validity with Range expression type validation rules.
  • Accuracy: Does data reflect the real-world objects or a verifiable source? For example, you can check email or address accuracy with Web service type validation rules or use Transformation list type action rules.
  • Integrity: Are the relations between entities and attributes consistent? Within tables and between tables? For example, you can check integrity with Range expression type or Data pattern type validation rules.
  • Timeliness: Is the data available at the time needed? For example, you can check timeliness with Mandatory type or Range expression type validation rules.
  • Completeness: Is all necessary data present? For example, you can control completeness with Mandatory type validation rules or action rules.

If you can't find the information you are looking for, you can:


Set up data quality policies

Set up data quality policy versions
Set up validation rules
Set up duplicate check rules
Set up enrichment rules
Set up action rules
Set up organization assignment
Exchange data quality policy versions

Manage data quality policy changes
Manage data quality policy changes - Advanced
Monitor data quality policy changes

General setup

In the Data Quality studio, you can define several general settings.

Set Data quality studio parameters

Set up dynamic queries

Set up web service configuration

Set up configurable lookup

Set up data pattern

Set up duplicate check

Set up condition table mapping

Set up secured values

Set up data quality assessment project

Set up reason codes

Apply data quality policy rules

You can apply data quality policy rules in several ways:

  • On manually entering or updating records.
  • On data import into D365 F&SCM with a Connectivity studio message.
  • On doing a quality assessment in Data quality studio.

Apply data quality rules on entering or updating a record

Apply data quality rules on data quality assessment

Apply data quality rules on data import with Connectivity studio

Monitor data quality

Monitor and clean up data quality execution history